Dataset info
| Number of variables | 71 |
|---|---|
| Number of observations | 1078349 |
| Missing cells | 43891956 (57.3%) |
| Duplicate rows | 62095 (5.8%) |
| Total size in memory | 584.1 MiB |
| Average record size in memory | 568.0 B |
Variables types
| Numeric | 10 |
|---|---|
| Categorical | 25 |
| Boolean | 31 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 2 |
| Unsupported | 3 |
Warnings
| Dataset has 62095 (5.8%) duplicate rows | Warning |
activitynumber has 118382 (11.0%) zeros | Zeros |
activitynumber has 506097 (46.9%) missing values | Missing |
activitywotype has 736387 (68.3%) missing values | Missing |
apptnumber has a high cardinality: 476000 distinct values | Warning |
atime_of_assignment has a high cardinality: 86501 distinct values | Warning |
atime_of_assignment has 220980 (20.5%) missing values | Missing |
atime_of_booking has a high cardinality: 300967 distinct values | Warning |
atime_of_booking has 22601 (2.1%) missing values | Missing |
barrio has a high cardinality: 75 distinct values | Warning |
ctime_delivered_end has a high cardinality: 7271 distinct values | Warning |
ctime_delivered_end has 1065531 (98.8%) missing values | Missing |
date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
date has a high cardinality: 688 distinct values | Warning |
empresa_contratista has a high cardinality: 211 distinct values | Warning |
empresa_solicitante has a high cardinality: 142 distinct values | Warning |
estado_general has 413552 (38.4%) missing values | Missing |
fin_obra only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
fin_obra has a high cardinality: 903 distinct values | Warning |
gp_nuevo has 1055577 (97.9%) missing values | Missing |
inicio_obra only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
inicio_obra has a high cardinality: 878 distinct values | Warning |
latitude is highly skewed (γ1 = 54.70228489) | Skewed |
longitude is highly correlated with latitude (ρ = 0.9215028308) | Rejected |
mobileactacomproba is an unsupported type, check if it needs cleaning or further analysis | Warning |
mobileactaintima is an unsupported type, check if it needs cleaning or further analysis | Warning |
mobileactasecuestro is highly correlated with activitynumber (ρ = 0.9984427709) | Rejected |
mobilec01 has 1077398 (99.9%) missing values | Missing |
mobilec02 has 1077328 (99.9%) missing values | Missing |
mobilec03 has 1078292 (> 99.9%) missing values | Missing |
mobilec06 has 1062952 (98.6%) missing values | Missing |
mobilec07 has 1030722 (95.6%) missing values | Missing |
mobilec08 has 1052921 (97.6%) missing values | Missing |
mobilec09 has 1077426 (99.9%) missing values | Missing |
mobilec10 has 1061860 (98.5%) missing values | Missing |
mobilec11 has 1059402 (98.2%) missing values | Missing |
mobilec12 has 1024497 (95.0%) missing values | Missing |
mobilec13 has 1020505 (94.6%) missing values | Missing |
mobilec14 has 1024150 (95.0%) missing values | Missing |
mobilec15 has 1071867 (99.4%) missing values | Missing |
mobilec16 has 1073770 (99.6%) missing values | Missing |
mobilec17 has 1041473 (96.6%) missing values | Missing |
mobilec18 has 1076218 (99.8%) missing values | Missing |
mobilec20 has 1062097 (98.5%) missing values | Missing |
mobilec21 has 1051458 (97.5%) missing values | Missing |
mobilec22 has 1077981 (> 99.9%) missing values | Missing |
mobilec23 has 1068774 (99.1%) missing values | Missing |
mobilec24 has 1070994 (99.3%) missing values | Missing |
mobilec25 has 1040999 (96.5%) missing values | Missing |
mobilec26 has 1053278 (97.7%) missing values | Missing |
mobilec27 has 1078161 (> 99.9%) missing values | Missing |
mobilec28 has 1078206 (> 99.9%) missing values | Missing |
mobilec29 has 1077169 (99.9%) missing values | Missing |
mobilec30 has 1073920 (99.6%) missing values | Missing |
mobilec31 has 1073368 (99.5%) missing values | Missing |
mobilec32 has 1076972 (99.9%) missing values | Missing |
mobilec33 has 1076289 (99.8%) missing values | Missing |
mobilec34 has 1075658 (99.8%) missing values | Missing |
mobiledesnivel is an unsupported type, check if it needs cleaning or further analysis | Warning |
mobileseveridad has 1057405 (98.1%) missing values | Missing |
no_realizado has a high cardinality: 189 distinct values | Warning |
no_realizado has 658587 (61.1%) missing values | Missing |
obra_ancho is highly skewed (γ1 = 45.87975551) | Skewed |
obra_profundidad is highly skewed (γ1 = 41.11138068) | Skewed |
obra_superficie_m2 is highly skewed (γ1 = 80.83312449) | Skewed |
obra_volumen_m3 is highly skewed (γ1 = 106.1798117) | Skewed |
resource_name has a high cardinality: 393 distinct values | Warning |
severidad has 877266 (81.4%) missing values | Missing |
streetaddress has a high cardinality: 216053 distinct values | Warning |
traveltime has 434809 (40.3%) zeros | Zeros |
traveltime has 35148 (3.3%) missing values | Missing |
activity_status
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| complete | |
|---|---|
| cancelled | |
| suspended | 133289 |
| Other values (4) | 64180 |
| Value | Count | Frequency (%) | |
| complete | 674364 | 62.5% | |
| cancelled | 206516 | 19.2% | |
| suspended | 133289 | 12.4% | |
| pending | 48387 | 4.5% | |
| deleted | 15763 | 1.5% | |
| started | 28 | < 0.1% | |
| notdone | 2 | < 0.1% |
| Max length | 9 |
|---|---|
| Mean length | 8.255599069 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
activitynumber
Numeric
| Distinct count | 1374 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 46.9% |
| Missing (n) | 506097 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 21.15225111 |
|---|---|
| Minimum | 0 |
| Maximum | 1377 |
| Zeros (%) | 11.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| Median | 14 |
| Q3 | 27 |
| 95-th percentile | 45 |
| Maximum | 1377 |
| Range | 1377 |
| Interquartile range | 24 |
Descriptive statistics
| Standard deviation | 51.11215652 |
|---|---|
| Coef of variation | 2.416393237 |
| Kurtosis | 247.9084389 |
| Mean | 21.15225111 |
| MAD | 17.72783814 |
| Skewness | 13.38171621 |
| Sum | 12104418 |
| Variance | 2612.452544 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 118382 | 11.0% | |
| 2 | 12209 | 1.1% | |
| 1 | 12161 | 1.1% | |
| 6 | 12153 | 1.1% | |
| 3 | 12128 | 1.1% | |
| 5 | 12118 | 1.1% | |
| 7 | 12089 | 1.1% | |
| 4 | 12086 | 1.1% | |
| 10 | 12065 | 1.1% | |
| 9 | 12041 | 1.1% | |
| Other values (1363) | 344820 | 32.0% | |
| (Missing) | 506097 | 46.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 118382 | 11.0% | |
| 1 | 12161 | 1.1% | |
| 2 | 12209 | 1.1% | |
| 3 | 12128 | 1.1% | |
| 4 | 12086 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1377 | 1 | < 0.1% | |
| 1373 | 1 | < 0.1% | |
| 1372 | 1 | < 0.1% | |
| 1371 | 1 | < 0.1% | |
| 1370 | 1 | < 0.1% |
activitytype
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| regular | |
|---|---|
| reopened | 4 |
| Value | Count | Frequency (%) | |
| regular | 1078345 | > 99.9% | |
| reopened | 4 | < 0.1% |
| Max length | 8 |
|---|---|
| Mean length | 7.000003709 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
activitywotype
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 68.3% |
| Missing (n) | 736387 |
| 4 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 4 | 341962 | 31.7% | |
| (Missing) | 736387 | 68.3% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
aid
Numeric
| Distinct count | 968605 |
|---|---|
| Unique (%) | 89.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 646952.7044 |
|---|---|
| Minimum | 362 |
| Maximum | 1375807 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 362 |
|---|---|
| 5-th percentile | 72694.4 |
| Q1 | 301777 |
| Median | 642904 |
| Q3 | 962830 |
| 95-th percentile | 1254587.4 |
| Maximum | 1375807 |
| Range | 1375445 |
| Interquartile range | 661053 |
Descriptive statistics
| Standard deviation | 382403.7259 |
|---|---|
| Coef of variation | 0.5910845156 |
| Kurtosis | -1.222591575 |
| Mean | 646952.7044 |
| MAD | 336080.0432 |
| Skewness | 0.0499061483 |
| Sum | 6.976408018e+11 |
| Variance | 1.462326096e+11 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[3.6200000e+02 3.8150000e+02 4.8250000e+02 6.3450000e+02 8.4750000e+02 ... 1.3748225e+06 1.3752335e+06 1.3753365e+06 1.3755440e+06 1.3758070e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 736328 | 25 | < 0.1% | |
| 929130 | 24 | < 0.1% | |
| 929186 | 24 | < 0.1% | |
| 947031 | 24 | < 0.1% | |
| 937582 | 23 | < 0.1% | |
| 883548 | 23 | < 0.1% | |
| 953310 | 23 | < 0.1% | |
| 960301 | 23 | < 0.1% | |
| 966330 | 23 | < 0.1% | |
| 976611 | 23 | < 0.1% | |
| Other values (968595) | 1078114 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 362 | 1 | < 0.1% | |
| 363 | 1 | < 0.1% | |
| 364 | 1 | < 0.1% | |
| 365 | 1 | < 0.1% | |
| 367 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1375807 | 1 | < 0.1% | |
| 1375806 | 1 | < 0.1% | |
| 1375801 | 1 | < 0.1% | |
| 1375798 | 1 | < 0.1% | |
| 1375797 | 1 | < 0.1% |
apptnumber
Categorical
| Distinct count | 476000 |
|---|---|
| Unique (%) | 44.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 140008548511 | 69 |
|---|---|
| 140010675740 | 63 |
| 140010675730 | 63 |
| Other values (475997) |
| Value | Count | Frequency (%) | |
| 140008548511 | 69 | < 0.1% | |
| 140010675740 | 63 | < 0.1% | |
| 140010675730 | 63 | < 0.1% | |
| 140010675710 | 62 | < 0.1% | |
| 140010675720 | 61 | < 0.1% | |
| 140010675930 | 60 | < 0.1% | |
| 140010675920 | 60 | < 0.1% | |
| 140010675910 | 58 | < 0.1% | |
| 140010675940 | 57 | < 0.1% | |
| 140010675912 | 57 | < 0.1% | |
| Other values (475990) | 1077739 | 99.9% |
| Max length | 19 |
|---|---|
| Mean length | 12.01512868 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
atime_of_assignment
Categorical
| Distinct count | 86501 |
|---|---|
| Unique (%) | 8.0% |
| Missing (%) | 20.5% |
| Missing (n) | 220980 |
| 2018-12-14T13:18:34Z | 24245 |
|---|---|
| 2019-01-16T12:36:08Z | 4296 |
| 2018-12-28T09:47:07Z | 3576 |
| Other values (86497) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2018-12-14T13:18:34Z | 24245 | 2.2% | |
| 2019-01-16T12:36:08Z | 4296 | 0.4% | |
| 2018-12-28T09:47:07Z | 3576 | 0.3% | |
| 2018-12-28T12:01:46Z | 3324 | 0.3% | |
| 2018-12-21T12:56:53Z | 2836 | 0.3% | |
| 2018-01-03T12:26:43Z | 2799 | 0.3% | |
| 2018-01-10T14:01:22Z | 2662 | 0.2% | |
| 2018-01-16T14:32:07Z | 2421 | 0.2% | |
| 2018-03-12T14:38:13Z | 2412 | 0.2% | |
| 2018-04-17T12:15:32Z | 2367 | 0.2% | |
| Other values (86490) | 806431 | 74.8% | |
| (Missing) | 220980 | 20.5% |
| Max length | 20 |
|---|---|
| Mean length | 16.51628554 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
atime_of_booking
Categorical
| Distinct count | 300967 |
|---|---|
| Unique (%) | 27.9% |
| Missing (%) | 2.1% |
| Missing (n) | 22601 |
| 2019-02-07T12:48:33Z | 1022 |
|---|---|
| 2019-01-28T12:35:37Z | 856 |
| 2019-02-04T14:01:16Z | 791 |
| Other values (300963) | |
| (Missing) | 22601 |
| Value | Count | Frequency (%) | |
| 2019-02-07T12:48:33Z | 1022 | 0.1% | |
| 2019-01-28T12:35:37Z | 856 | 0.1% | |
| 2019-02-04T14:01:16Z | 791 | 0.1% | |
| 2019-01-31T13:34:02Z | 768 | 0.1% | |
| 2019-01-30T12:01:46Z | 746 | 0.1% | |
| 2018-12-05T12:59:49Z | 740 | 0.1% | |
| 2019-01-29T12:22:09Z | 729 | 0.1% | |
| 2019-02-05T13:53:47Z | 700 | 0.1% | |
| 2019-02-01T13:19:03Z | 635 | 0.1% | |
| 2019-02-01T12:26:02Z | 612 | 0.1% | |
| Other values (300956) | 1048149 | 97.2% | |
| (Missing) | 22601 | 2.1% |
| Max length | 20 |
|---|---|
| Mean length | 19.64369884 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
barrio
Categorical
| Distinct count | 75 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 375 |
| Palermo | 69943 |
|---|---|
| Flores | 61586 |
| Recoleta | 41469 |
| Other values (71) |
| Value | Count | Frequency (%) | |
| Palermo | 69943 | 6.5% | |
| Flores | 61586 | 5.7% | |
| Recoleta | 41469 | 3.8% | |
| Villa Urquiza | 40955 | 3.8% | |
| Caballito | 39792 | 3.7% | |
| Belgrano | 39250 | 3.6% | |
| Villa Devoto | 38293 | 3.6% | |
| Barracas | 31983 | 3.0% | |
| Nueva Pompeya | 31088 | 2.9% | |
| Liniers | 30912 | 2.9% | |
| Other values (64) | 652703 | 60.5% |
| Max length | 17 |
|---|---|
| Mean length | 10.31114602 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
clase_aviso
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 7 |
| EM | |
|---|---|
| AP | |
| CG | 98342 |
| Value | Count | Frequency (%) | |
| EM | 621012 | 57.6% | |
| AP | 358938 | 33.3% | |
| CG | 98342 | 9.1% | |
| SU | 50 | < 0.1% | |
| (Missing) | 7 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 2.000006491 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
comuna
Categorical
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| C11 | 108009 |
|---|---|
| C04 | 107623 |
| C01 | 98462 |
| Other values (13) |
| Value | Count | Frequency (%) | |
| C11 | 108009 | 10.0% | |
| C04 | 107623 | 10.0% | |
| C01 | 98462 | 9.1% | |
| C07 | 87051 | 8.1% | |
| C12 | 86105 | 8.0% | |
| C10 | 81305 | 7.5% | |
| C13 | 74306 | 6.9% | |
| C15 | 73715 | 6.8% | |
| C09 | 73424 | 6.8% | |
| C14 | 70025 | 6.5% | |
| Other values (6) | 218323 | 20.2% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
ctime_delivered_end
Categorical
| Distinct count | 7271 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 98.8% |
| Missing (n) | 1065531 |
| 2019-02-05T10:38:38Z | 21 |
|---|---|
| 2019-02-05T10:38:36Z | 20 |
| 2019-01-28T07:52:10Z | 19 |
| Other values (7267) | 12758 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2019-02-05T10:38:38Z | 21 | < 0.1% | |
| 2019-02-05T10:38:36Z | 20 | < 0.1% | |
| 2019-01-28T07:52:10Z | 19 | < 0.1% | |
| 2019-01-31T07:02:00Z | 18 | < 0.1% | |
| 2019-01-29T07:44:23Z | 16 | < 0.1% | |
| 2019-02-05T10:38:31Z | 15 | < 0.1% | |
| 2019-01-25T07:32:11Z | 14 | < 0.1% | |
| 2019-02-05T10:38:37Z | 14 | < 0.1% | |
| 2019-02-05T10:38:32Z | 14 | < 0.1% | |
| 2019-02-05T10:38:33Z | 13 | < 0.1% | |
| Other values (7260) | 12654 | 1.2% | |
| (Missing) | 1065531 | 98.8% |
| Max length | 20 |
|---|---|
| Mean length | 3.202073726 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
date
Categorical
| Distinct count | 688 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2018-12-17T00:00:00Z | 31215 |
|---|---|
| 2018-04-03T00:00:00Z | 13614 |
| 2018-12-08T00:00:00Z | 8815 |
| Other values (685) |
| Value | Count | Frequency (%) | |
| 2018-12-17T00:00:00Z | 31215 | 2.9% | |
| 2018-04-03T00:00:00Z | 13614 | 1.3% | |
| 2018-12-08T00:00:00Z | 8815 | 0.8% | |
| 2018-01-22T00:00:00Z | 8814 | 0.8% | |
| 2018-12-05T00:00:00Z | 7428 | 0.7% | |
| 2019-01-17T00:00:00Z | 7264 | 0.7% | |
| 2017-11-23T00:00:00Z | 5355 | 0.5% | |
| 2018-12-30T00:00:00Z | 4808 | 0.4% | |
| 2018-12-29T00:00:00Z | 4612 | 0.4% | |
| 2018-11-17T00:00:00Z | 4558 | 0.4% | |
| Other values (678) | 981866 | 91.1% |
| Max length | 20 |
|---|---|
| Mean length | 20 |
| Min length | 20 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
duracion
Numeric
| Distinct count | 238 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.81843077 |
|---|---|
| Minimum | 1 |
| Maximum | 646 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 15 |
| Median | 15 |
| Q3 | 30 |
| 95-th percentile | 89 |
| Maximum | 646 |
| Range | 645 |
| Interquartile range | 15 |
Descriptive statistics
| Standard deviation | 24.74469892 |
|---|---|
| Coef of variation | 0.9970291494 |
| Kurtosis | 21.30823836 |
| Mean | 24.81843077 |
| MAD | 15.43543154 |
| Skewness | 3.588861338 |
| Sum | 26762930 |
| Variance | 612.3001245 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 333. 358.5 368. 476.5 646. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 15 | 535344 | 49.6% | |
| 30 | 95739 | 8.9% | |
| 7 | 35149 | 3.3% | |
| 12 | 29219 | 2.7% | |
| 10 | 25300 | 2.3% | |
| 90 | 24564 | 2.3% | |
| 18 | 23964 | 2.2% | |
| 32 | 23570 | 2.2% | |
| 8 | 21132 | 2.0% | |
| 31 | 18398 | 1.7% | |
| Other values (228) | 245970 | 22.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 590 | 0.1% | |
| 2 | 11085 | 1.0% | |
| 3 | 1013 | 0.1% | |
| 4 | 4358 | 0.4% | |
| 5 | 7668 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 646 | 4 | < 0.1% | |
| 612 | 2 | < 0.1% | |
| 545 | 4 | < 0.1% | |
| 477 | 2 | < 0.1% | |
| 476 | 6 | < 0.1% |
empresa_contratista
Categorical
| Distinct count | 211 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 654 |
| COSUGAS SRL | |
|---|---|
| EMA SERVICIOS S.A. | 132351 |
| AUTOTROL S.A.CONSTRUMAN S.A. UTE | 82513 |
| Other values (207) |
| Value | Count | Frequency (%) | |
| COSUGAS SRL | 165561 | 15.4% | |
| EMA SERVICIOS S.A. | 132351 | 12.3% | |
| AUTOTROL S.A.CONSTRUMAN S.A. UTE | 82513 | 7.7% | |
| AGUA Y SANEAMIENTOS ARGENTINOS SOCI | 76277 | 7.1% | |
| ARGENCOBRA S.A. | 67193 | 6.2% | |
| MANTELECTRIC I.C.I.S.A. | 44347 | 4.1% | |
| INARTECO S.A. | 43683 | 4.1% | |
| C Y E CONSTRUCCIONES SA | 39739 | 3.7% | |
| ZUBDESA S.A | 34172 | 3.2% | |
| POSE S.A | 28538 | 2.6% | |
| Other values (200) | 363321 | 33.7% |
| Max length | 35 |
|---|---|
| Mean length | 18.11381102 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
empresa_solicitante
Categorical
| Distinct count | 142 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 837 |
| AGUA Y SANEAMIENTOS ARGENTINOS SOCI | |
|---|---|
| EDESUR S.A. | |
| METROGAS S.A | |
| Other values (138) |
| Value | Count | Frequency (%) | |
| AGUA Y SANEAMIENTOS ARGENTINOS SOCI | 373787 | 34.7% | |
| EDESUR S.A. | 142352 | 13.2% | |
| METROGAS S.A | 101312 | 9.4% | |
| AUTOTROL S.A.CONSTRUMAN S.A. UTE | 82513 | 7.7% | |
| METROGAS S.A. | 82359 | 7.6% | |
| EDENOR SA | 65922 | 6.1% | |
| DIRECCION GRAL DE ALUMBRADO | 39976 | 3.7% | |
| AYSA S.A. | 31971 | 3.0% | |
| NSS S.A. | 22024 | 2.0% | |
| TELEFONICA DE ARGENTINA S.A. | 21261 | 2.0% | |
| Other values (131) | 114035 | 10.6% |
| Max length | 35 |
|---|---|
| Mean length | 23.04143278 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
estado_general
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 38.4% |
| Missing (n) | 413552 |
| A_DBE | |
|---|---|
| A_DME | |
| AC_NEA | |
| Other values (6) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| A_DBE | 304268 | 28.2% | |
| A_DME | 134676 | 12.5% | |
| AC_NEA | 122376 | 11.3% | |
| AC_OEE | 95576 | 8.9% | |
| C_PBE | 3164 | 0.3% | |
| Nueva Apertura | 2404 | 0.2% | |
| C_PME | 1307 | 0.1% | |
| AC_OI | 1023 | 0.1% | |
| 1 | 3 | < 0.1% | |
| (Missing) | 413552 | 38.4% |
| Max length | 14 |
|---|---|
| Mean length | 4.455159693 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
fin_obra
Categorical
| Distinct count | 903 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2018-12-12T00:00:00Z | 8497 |
|---|---|
| 2019-02-11T00:00:00Z | 7934 |
| 2018-12-20T00:00:00Z | 7452 |
| Other values (900) |
| Value | Count | Frequency (%) | |
| 2018-12-12T00:00:00Z | 8497 | 0.8% | |
| 2019-02-11T00:00:00Z | 7934 | 0.7% | |
| 2018-12-20T00:00:00Z | 7452 | 0.7% | |
| 2018-11-26T00:00:00Z | 6684 | 0.6% | |
| 2019-02-05T00:00:00Z | 6507 | 0.6% | |
| 2018-12-17T00:00:00Z | 6212 | 0.6% | |
| 2018-12-11T00:00:00Z | 5544 | 0.5% | |
| 2017-12-05T00:00:00Z | 5475 | 0.5% | |
| 2018-12-16T00:00:00Z | 4702 | 0.4% | |
| 2018-12-10T00:00:00Z | 4588 | 0.4% | |
| Other values (893) | 1014754 | 94.1% |
| Max length | 20 |
|---|---|
| Mean length | 20 |
| Min length | 20 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
gp_nuevo
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 97.9% |
| Missing (n) | 1055577 |
| VE8 | 17115 |
|---|---|
| CA1 | 5657 |
| (Missing) |
| Value | Count | Frequency (%) | |
| VE8 | 17115 | 1.6% | |
| CA1 | 5657 | 0.5% | |
| (Missing) | 1055577 | 97.9% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
grupo_planificador
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| VE4 | |
|---|---|
| VE5 | |
| VE7 | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| VE4 | 398504 | 37.0% | |
| VE5 | 371493 | 34.5% | |
| VE7 | 205383 | 19.0% | |
| VE6 | 102923 | 9.5% | |
| CA1 | 45 | < 0.1% | |
| (Missing) | 1 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
inicio_obra
Categorical
| Distinct count | 878 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2018-11-12T00:00:00Z | 12882 |
|---|---|
| 2018-11-28T00:00:00Z | 10755 |
| 2018-12-10T00:00:00Z | 9547 |
| Other values (875) |
| Value | Count | Frequency (%) | |
| 2018-11-12T00:00:00Z | 12882 | 1.2% | |
| 2018-11-28T00:00:00Z | 10755 | 1.0% | |
| 2018-12-10T00:00:00Z | 9547 | 0.9% | |
| 2018-12-03T00:00:00Z | 8777 | 0.8% | |
| 2019-01-28T00:00:00Z | 6766 | 0.6% | |
| 2018-11-14T00:00:00Z | 6376 | 0.6% | |
| 2018-11-27T00:00:00Z | 6164 | 0.6% | |
| 2018-11-08T00:00:00Z | 5906 | 0.5% | |
| 2019-01-21T00:00:00Z | 5668 | 0.5% | |
| 2018-11-13T00:00:00Z | 5594 | 0.5% | |
| Other values (868) | 999914 | 92.7% |
| Max length | 20 |
|---|---|
| Mean length | 20 |
| Min length | 20 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
latitude
Numeric
| Distinct count | 14161 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -34.60395863 |
|---|---|
| Minimum | -58.48939 |
| Maximum | 0 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | -58.48939 |
|---|---|
| 5-th percentile | -34.65957 |
| Q1 | -34.6344 |
| Median | -34.6128 |
| Q3 | -34.58983 |
| 95-th percentile | -34.55743 |
| Maximum | 0 |
| Range | 58.48939 |
| Interquartile range | 0.04457 |
Descriptive statistics
| Standard deviation | 0.567509261 |
|---|---|
| Coef of variation | -0.01640012541 |
| Kurtosis | 3588.076983 |
| Mean | -34.60395863 |
| MAD | 0.035682058 |
| Skewness | 54.70228489 |
| Sum | -37315144.18 |
| Variance | 0.3220667613 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-58.48939 -58.47059 -58.46898 -58.44806 -34.70298 ... -34.535965 -34.5359 -34.5357 -17.267775 0. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -34.62861 | 3059 | 0.3% | |
| -34.65655 | 904 | 0.1% | |
| -34.64453 | 807 | 0.1% | |
| -34.67462 | 687 | 0.1% | |
| -34.62947 | 637 | 0.1% | |
| -34.59639 | 627 | 0.1% | |
| -34.60461 | 602 | 0.1% | |
| -34.61769 | 551 | 0.1% | |
| -34.67311 | 541 | 0.1% | |
| -34.67278 | 532 | < 0.1% | |
| Other values (14151) | 1069402 | 99.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -58.48939 | 1 | < 0.1% | |
| -58.48777 | 1 | < 0.1% | |
| -58.47063 | 2 | < 0.1% | |
| -58.47055 | 1 | < 0.1% | |
| -58.47049 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0 | 272 | < 0.1% | |
| -34.53555 | 15 | < 0.1% | |
| -34.53585 | 1 | < 0.1% | |
| -34.53595 | 50 | < 0.1% | |
| -34.53598 | 4 | < 0.1% |
longitude
Highly correlated
This variable is highly correlated with latitude and should be ignored for analysis
| Correlation | 0.9215028308 |
|---|
mobileactacomproba
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
mobileactaintima
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
mobileactasecuestro
Highly correlated
This variable is highly correlated with activitynumber and should be ignored for analysis
| Correlation | 0.9984427709 |
|---|
mobilec01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 1077398 |
| 1 | 951 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 951 | 0.1% | |
| (Missing) | 1077398 | 99.9% |
mobilec02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 1077328 |
| 1 | 1021 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 1021 | 0.1% | |
| (Missing) | 1077328 | 99.9% |
mobilec03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1078292 |
| 1 | 57 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 57 | < 0.1% | |
| (Missing) | 1078292 | > 99.9% |
mobilec06
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.6% |
| Missing (n) | 1062952 |
| 1 | 15397 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 15397 | 1.4% | |
| (Missing) | 1062952 | 98.6% |
mobilec07
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 95.6% |
| Missing (n) | 1030722 |
| 1 | 47627 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 47627 | 4.4% | |
| (Missing) | 1030722 | 95.6% |
mobilec08
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 97.6% |
| Missing (n) | 1052921 |
| 1 | 25428 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 25428 | 2.4% | |
| (Missing) | 1052921 | 97.6% |
mobilec09
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 1077426 |
| 1 | 923 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 923 | 0.1% | |
| (Missing) | 1077426 | 99.9% |
mobilec10
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.5% |
| Missing (n) | 1061860 |
| 1 | 16489 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 16489 | 1.5% | |
| (Missing) | 1061860 | 98.5% |
mobilec11
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.2% |
| Missing (n) | 1059402 |
| 1 | 18947 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 18947 | 1.8% | |
| (Missing) | 1059402 | 98.2% |
mobilec12
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 95.0% |
| Missing (n) | 1024497 |
| 1 | 53852 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 53852 | 5.0% | |
| (Missing) | 1024497 | 95.0% |
mobilec13
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 94.6% |
| Missing (n) | 1020505 |
| 1 | 57844 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 57844 | 5.4% | |
| (Missing) | 1020505 | 94.6% |
mobilec14
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 95.0% |
| Missing (n) | 1024150 |
| 1 | 54199 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 54199 | 5.0% | |
| (Missing) | 1024150 | 95.0% |
mobilec15
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.4% |
| Missing (n) | 1071867 |
| 1 | 6482 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 6482 | 0.6% | |
| (Missing) | 1071867 | 99.4% |
mobilec16
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.6% |
| Missing (n) | 1073770 |
| 1 | 4579 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 4579 | 0.4% | |
| (Missing) | 1073770 | 99.6% |
mobilec17
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 96.6% |
| Missing (n) | 1041473 |
| 1 | 36876 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 36876 | 3.4% | |
| (Missing) | 1041473 | 96.6% |
mobilec18
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.8% |
| Missing (n) | 1076218 |
| 1 | 2131 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 2131 | 0.2% | |
| (Missing) | 1076218 | 99.8% |
mobilec20
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.5% |
| Missing (n) | 1062097 |
| 1 | 16252 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 16252 | 1.5% | |
| (Missing) | 1062097 | 98.5% |
mobilec21
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 97.5% |
| Missing (n) | 1051458 |
| 1 | 26891 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 26891 | 2.5% | |
| (Missing) | 1051458 | 97.5% |
mobilec22
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1077981 |
| 1 | 368 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 368 | < 0.1% | |
| (Missing) | 1077981 | > 99.9% |
mobilec23
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.1% |
| Missing (n) | 1068774 |
| 1 | 9575 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 9575 | 0.9% | |
| (Missing) | 1068774 | 99.1% |
mobilec24
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.3% |
| Missing (n) | 1070994 |
| 1 | 7355 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 7355 | 0.7% | |
| (Missing) | 1070994 | 99.3% |
mobilec25
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 96.5% |
| Missing (n) | 1040999 |
| 1 | 37350 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 37350 | 3.5% | |
| (Missing) | 1040999 | 96.5% |
mobilec26
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 97.7% |
| Missing (n) | 1053278 |
| 1 | 25071 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 25071 | 2.3% | |
| (Missing) | 1053278 | 97.7% |
mobilec27
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1078161 |
| 1 | 188 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 188 | < 0.1% | |
| (Missing) | 1078161 | > 99.9% |
mobilec28
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1078206 |
| 1 | 143 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 143 | < 0.1% | |
| (Missing) | 1078206 | > 99.9% |
mobilec29
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 1077169 |
| 1 | 1180 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 1180 | 0.1% | |
| (Missing) | 1077169 | 99.9% |
mobilec30
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.6% |
| Missing (n) | 1073920 |
| 1 | 4429 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 4429 | 0.4% | |
| (Missing) | 1073920 | 99.6% |
mobilec31
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.5% |
| Missing (n) | 1073368 |
| 1 | 4981 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 4981 | 0.5% | |
| (Missing) | 1073368 | 99.5% |
mobilec32
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 1076972 |
| 1 | 1377 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 1377 | 0.1% | |
| (Missing) | 1076972 | 99.9% |
mobilec33
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.8% |
| Missing (n) | 1076289 |
| 1 | 2060 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 2060 | 0.2% | |
| (Missing) | 1076289 | 99.8% |
mobilec34
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.8% |
| Missing (n) | 1075658 |
| 1 | 2691 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 1 | 2691 | 0.2% | |
| (Missing) | 1075658 | 99.8% |
mobiledesnivel
Unsupported
This variable is an unsupported type, check if it needs cleaning or further analysis
| Unsupported value |
|---|
mobileseveridad
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 98.1% |
| Missing (n) | 1057405 |
| CMR | 8246 |
|---|---|
| GPA | 5671 |
| CPE | 3737 |
| Other values (4) | 3290 |
| (Missing) |
| Value | Count | Frequency (%) | |
| CMR | 8246 | 0.8% | |
| GPA | 5671 | 0.5% | |
| CPE | 3737 | 0.3% | |
| ELA | 1542 | 0.1% | |
| EPB | 916 | 0.1% | |
| CAM | 510 | < 0.1% | |
| CAB | 322 | < 0.1% | |
| (Missing) | 1057405 | 98.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
no_realizado
Categorical
| Distinct count | 189 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 61.1% |
| Missing (n) | 658587 |
| otros | |
|---|---|
| vacio | 74116 |
| Otra tarea asignada | 44683 |
| Other values (185) | 64120 |
| (Missing) |
| Value | Count | Frequency (%) | |
| otros | 236843 | 22.0% | |
| vacio | 74116 | 6.9% | |
| Otra tarea asignada | 44683 | 4.1% | |
| condiciones_climaticas | 18986 | 1.8% | |
| zona_postergada | 9323 | 0.9% | |
| ninguno | 7906 | 0.7% | |
| Enfermedad | 7230 | 0.7% | |
| Problemas con celular | 6544 | 0.6% | |
| 0 | 4084 | 0.4% | |
| 1 | 2244 | 0.2% | |
| Other values (178) | 7803 | 0.7% | |
| (Missing) | 658587 | 61.1% |
| Max length | 22 |
|---|---|
| Mean length | 4.849763852 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
obra_ancho
Numeric
| Distinct count | 364 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 9 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.8445371775 |
|---|---|
| Minimum | 0 |
| Maximum | 300 |
| Zeros (%) | 0.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.4 |
| Q1 | 0.6 |
| Median | 0.6 |
| Q3 | 1 |
| 95-th percentile | 1.2 |
| Maximum | 300 |
| Range | 300 |
| Interquartile range | 0.4 |
Descriptive statistics
| Standard deviation | 2.497631501 |
|---|---|
| Coef of variation | 2.957396746 |
| Kurtosis | 3155.598226 |
| Mean | 0.8445371775 |
| MAD | 0.3837972714 |
| Skewness | 45.87975551 |
| Sum | 910698.22 |
| Variance | 6.238163114 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.6 | 324562 | 30.1% | |
| 1 | 252859 | 23.4% | |
| 0.4 | 232935 | 21.6% | |
| 0.8 | 137616 | 12.8% | |
| 1.2 | 25766 | 2.4% | |
| 0.5 | 21856 | 2.0% | |
| 2 | 12882 | 1.2% | |
| 0.65 | 11270 | 1.0% | |
| 1.6 | 5958 | 0.6% | |
| 0.52 | 5598 | 0.5% | |
| Other values (353) | 47038 | 4.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2422 | 0.2% | |
| 0.04 | 3 | < 0.1% | |
| 0.06 | 5 | < 0.1% | |
| 0.1 | 106 | < 0.1% | |
| 0.11 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 300 | 1 | < 0.1% | |
| 289 | 5 | < 0.1% | |
| 252 | 2 | < 0.1% | |
| 250 | 3 | < 0.1% | |
| 220 | 8 | < 0.1% |
obra_largo
Numeric
| Distinct count | 1540 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 9 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.02670794 |
|---|---|
| Minimum | 0 |
| Maximum | 999 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 0.8 |
| Median | 1.2 |
| Q3 | 5 |
| 95-th percentile | 40 |
| Maximum | 999 |
| Range | 999 |
| Interquartile range | 4.2 |
Descriptive statistics
| Standard deviation | 22.03967638 |
|---|---|
| Coef of variation | 2.745792739 |
| Kurtosis | 250.791735 |
| Mean | 8.02670794 |
| MAD | 9.9764333 |
| Skewness | 10.6377537 |
| Sum | 8655520.24 |
| Variance | 485.7473349 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.6 | 198364 | 18.4% | |
| 1 | 148321 | 13.8% | |
| 1.2 | 83843 | 7.8% | |
| 2 | 72846 | 6.8% | |
| 10 | 59912 | 5.6% | |
| 0.8 | 55182 | 5.1% | |
| 4 | 45696 | 4.2% | |
| 0.4 | 43026 | 4.0% | |
| 3 | 35388 | 3.3% | |
| 5 | 34743 | 3.2% | |
| Other values (1529) | 301019 | 27.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1243 | 0.1% | |
| 0.06 | 8 | < 0.1% | |
| 0.08 | 28 | < 0.1% | |
| 0.1 | 81 | < 0.1% | |
| 0.11 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999 | 16 | < 0.1% | |
| 900 | 5 | < 0.1% | |
| 890 | 5 | < 0.1% | |
| 885 | 4 | < 0.1% | |
| 830 | 2 | < 0.1% |
obra_profundidad
Numeric
| Distinct count | 139 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 9 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.8243085947 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros (%) | 0.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.4 |
| Q1 | 0.6 |
| Median | 0.8 |
| Q3 | 1 |
| 95-th percentile | 1.3 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range | 0.4 |
Descriptive statistics
| Standard deviation | 0.8497834085 |
|---|---|
| Coef of variation | 1.030904462 |
| Kurtosis | 2676.936877 |
| Mean | 0.8243085947 |
| MAD | 0.2685200977 |
| Skewness | 41.11138068 |
| Sum | 888884.93 |
| Variance | 0.7221318413 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.6 | 285472 | 26.5% | |
| 1 | 208455 | 19.3% | |
| 0.8 | 203257 | 18.8% | |
| 0.4 | 98972 | 9.2% | |
| 1.2 | 60282 | 5.6% | |
| 0.7 | 40722 | 3.8% | |
| 1.1 | 35893 | 3.3% | |
| 1.3 | 28250 | 2.6% | |
| 0.65 | 27116 | 2.5% | |
| 2 | 15874 | 1.5% | |
| Other values (128) | 74047 | 6.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5085 | 0.5% | |
| 0.02 | 3 | < 0.1% | |
| 0.04 | 27 | < 0.1% | |
| 0.05 | 10 | < 0.1% | |
| 0.08 | 16 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 2 | < 0.1% | |
| 80 | 5 | < 0.1% | |
| 75 | 10 | < 0.1% | |
| 70 | 5 | < 0.1% | |
| 65 | 1 | < 0.1% |
obra_superficie_m2
Numeric
| Distinct count | 2425 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | < 0.1% |
| Missing (n) | 9 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.836598141 |
|---|---|
| Minimum | 0 |
| Maximum | 23882.82 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 0.48 |
| Median | 1 |
| Q3 | 4 |
| 95-th percentile | 22 |
| Maximum | 23882.82 |
| Range | 23882.82 |
| Interquartile range | 3.52 |
Descriptive statistics
| Standard deviation | 199.2474317 |
|---|---|
| Coef of variation | 22.54797927 |
| Kurtosis | 7560.372361 |
| Mean | 8.836598141 |
| MAD | 12.4355198 |
| Skewness | 80.83312449 |
| Sum | 9528857.239 |
| Variance | 39699.53904 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.36 | 163031 | 15.1% | |
| 1 | 129512 | 12.0% | |
| 4 | 63878 | 5.9% | |
| 1.2 | 39952 | 3.7% | |
| 2 | 37985 | 3.5% | |
| 0.8 | 36038 | 3.3% | |
| 0.96 | 36014 | 3.3% | |
| 0.72 | 32780 | 3.0% | |
| 0.48 | 30350 | 2.8% | |
| 0.64 | 28673 | 2.7% | |
| Other values (2414) | 480127 | 44.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2887 | 0.3% | |
| 0.0066 | 2 | < 0.1% | |
| 0.01 | 69 | < 0.1% | |
| 0.02 | 4 | < 0.1% | |
| 0.0225 | 75 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23882.82 | 10 | < 0.1% | |
| 22500 | 2 | < 0.1% | |
| 21228 | 31 | < 0.1% | |
| 15330 | 5 | < 0.1% | |
| 13596.4 | 39 | < 0.1% |
obra_volumen_m3
Numeric
| Distinct count | 3401 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | < 0.1% |
| Missing (n) | 9 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 29.12975427 |
|---|---|
| Minimum | 0 |
| Maximum | 358242.3 |
| Zeros (%) | 0.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.128 |
| Q1 | 0.384 |
| Median | 1 |
| Q3 | 3 |
| 95-th percentile | 17.28 |
| Maximum | 358242.3 |
| Range | 358242.3 |
| Interquartile range | 2.616 |
Descriptive statistics
| Standard deviation | 1990.947712 |
|---|---|
| Coef of variation | 68.34756289 |
| Kurtosis | 13095.34254 |
| Mean | 29.12975427 |
| MAD | 51.76345628 |
| Skewness | 106.1798117 |
| Sum | 31411779.22 |
| Variance | 3963872.792 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.216 | 117229 | 10.9% | |
| 1 | 115733 | 10.7% | |
| 0.432 | 53172 | 4.9% | |
| 0.64 | 33727 | 3.1% | |
| 4 | 23936 | 2.2% | |
| 2.6 | 23342 | 2.2% | |
| 0.72 | 22226 | 2.1% | |
| 1.92 | 18120 | 1.7% | |
| 0.96 | 17606 | 1.6% | |
| 0.275 | 16471 | 1.5% | |
| Other values (3390) | 636778 | 59.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 6739 | 0.6% | |
| 0.001 | 63 | < 0.1% | |
| 0.004 | 1 | < 0.1% | |
| 0.005 | 4 | < 0.1% | |
| 0.0064 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 358242.3 | 7 | < 0.1% | |
| 203946 | 39 | < 0.1% | |
| 202629.51 | 6 | < 0.1% | |
| 202552.2 | 2 | < 0.1% | |
| 200000 | 3 | < 0.1% |
resource_name
Categorical
| Distinct count | 393 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| VPA | 92532 |
|---|---|
| Vías Peatonales | 48263 |
| Aperturas | 28232 |
| Other values (390) |
| Value | Count | Frequency (%) | |
| VPA | 92532 | 8.6% | |
| Vías Peatonales | 48263 | 4.5% | |
| Aperturas | 28232 | 2.6% | |
| SCARANTE | 8322 | 0.8% | |
| ACADAVEIRA | 7989 | 0.7% | |
| MLEPEZ | 7883 | 0.7% | |
| SYANTORNO | 7846 | 0.7% | |
| SBUSTOS | 7734 | 0.7% | |
| AMANZETTI | 7646 | 0.7% | |
| Harilaos Belen | 7023 | 0.7% | |
| Other values (383) | 854879 | 79.3% |
| Max length | 34 |
|---|---|
| Mean length | 12.42721883 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
severidad
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 81.4% |
| Missing (n) | 877266 |
| 3 | 86376 |
|---|---|
| 2 | 80472 |
| 1 | 34235 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 3 | 86376 | 8.0% | |
| 2 | 80472 | 7.5% | |
| 1 | 34235 | 3.2% | |
| (Missing) | 877266 | 81.4% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
status_usuario
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| PLAN | |
|---|---|
| REOK | |
| SERV | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| PLAN | 403482 | 37.4% | |
| REOK | 255378 | 23.7% | |
| SERV | 149166 | 13.8% | |
| VERI | 145893 | 13.5% | |
| INEX | 124430 | 11.5% |
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
streetaddress
Categorical
| Distinct count | 216053 |
|---|---|
| Unique (%) | 20.0% |
| Missing (%) | 0.1% |
| Missing (n) | 1544 |
| ARTIGAS, JOSE GERVASIO, GRAL. 7, CABA | 2983 |
|---|---|
| PASAJE C y BENEDETTI, OSVALDO E., DIP.NAC., CABA | 849 |
| CONTINUACION AV. COREA (SIN NOMBRE OFICIAL) y BONORINO, ESTEBAN, CNEL. AV., CABA | 653 |
| Other values (216049) | |
| (Missing) | 1544 |
| Value | Count | Frequency (%) | |
| ARTIGAS, JOSE GERVASIO, GRAL. 7, CABA | 2983 | 0.3% | |
| PASAJE C y BENEDETTI, OSVALDO E., DIP.NAC., CABA | 849 | 0.1% | |
| CONTINUACION AV. COREA (SIN NOMBRE OFICIAL) y BONORINO, ESTEBAN, CNEL. AV., CABA | 653 | 0.1% | |
| LA RABIDA (S) AV. 6, CABA | 345 | < 0.1% | |
| CARABELAS 235, CABA | 320 | < 0.1% | |
| ACEVEDO 22, CABA | 240 | < 0.1% | |
| DE LA ROSA, JOSE I., DR. 5841 | 194 | < 0.1% | |
| LA RABIDA (S) AV. 22, CABA | 192 | < 0.1% | |
| LA RABIDA (S) AV. 5, CABA | 191 | < 0.1% | |
| ALBERTI 601 | 182 | < 0.1% | |
| Other values (216042) | 1070656 | 99.3% | |
| (Missing) | 1544 | 0.1% |
| Max length | 80 |
|---|---|
| Mean length | 18.79977447 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
tipo_obra
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 2 |
| ACERA | |
|---|---|
| CALZADA | 27597 |
| (Missing) | 2 |
| Value | Count | Frequency (%) | |
| ACERA | 1050750 | 97.4% | |
| CALZADA | 27597 | 2.6% | |
| (Missing) | 2 | < 0.1% |
| Max length | 7 |
|---|---|
| Mean length | 5.051180091 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
traveltime
Numeric
| Distinct count | 576 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 3.3% |
| Missing (n) | 35148 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.283067213 |
|---|---|
| Minimum | 0 |
| Maximum | 812 |
| Zeros (%) | 40.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 5 |
| 95-th percentile | 17 |
| Maximum | 812 |
| Range | 812 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 19.8877427 |
|---|---|
| Coef of variation | 3.764431133 |
| Kurtosis | 250.2847915 |
| Mean | 5.283067213 |
| MAD | 6.480273072 |
| Skewness | 13.24003729 |
| Sum | 5511301 |
| Variance | 395.5223096 |
| Memory size | 8.2 MiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 434809 | 40.3% | |
| 1 | 140235 | 13.0% | |
| 2 | 76851 | 7.1% | |
| 3 | 64140 | 5.9% | |
| 5 | 59623 | 5.5% | |
| 4 | 52010 | 4.8% | |
| 10 | 32442 | 3.0% | |
| 6 | 32144 | 3.0% | |
| 7 | 24990 | 2.3% | |
| 8 | 19600 | 1.8% | |
| Other values (565) | 106357 | 9.9% | |
| (Missing) | 35148 | 3.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 434809 | 40.3% | |
| 1 | 140235 | 13.0% | |
| 2 | 76851 | 7.1% | |
| 3 | 64140 | 5.9% | |
| 4 | 52010 | 4.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 812 | 1 | < 0.1% | |
| 790 | 1 | < 0.1% | |
| 778 | 1 | < 0.1% | |
| 750 | 1 | < 0.1% | |
| 747 | 1 | < 0.1% |
First rows
| activity_status | activitynumber | activitytype | activitywotype | aid | apptnumber | atime_of_assignment | atime_of_booking | barrio | clase_aviso | comuna | ctime_delivered_end | date | duracion | empresa_contratista | empresa_solicitante | estado_general | fin_obra | gp_nuevo | grupo_planificador | inicio_obra | latitude | longitude | mobileactacomproba | mobileactaintima | mobileactasecuestro | mobilec01 | mobilec02 | mobilec03 | mobilec06 | mobilec07 | mobilec08 | mobilec09 | mobilec10 | mobilec11 | mobilec12 | mobilec13 | mobilec14 | mobilec15 | mobilec16 | mobilec17 | mobilec18 | mobilec20 | mobilec21 | mobilec22 | mobilec23 | mobilec24 | mobilec25 | mobilec26 | mobilec27 | mobilec28 | mobilec29 | mobilec30 | mobilec31 | mobilec32 | mobilec33 | mobilec34 | mobiledesnivel | mobileseveridad | no_realizado | obra_ancho | obra_largo | obra_profundidad | obra_superficie_m2 | obra_volumen_m3 | resource_name | severidad | status_usuario | streetaddress | tipo_obra | traveltime | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | cancelled | 0.0 | regular | 4.0 | 120801 | 150020503870 | NaN | 2017-10-13T11:27:35Z | Belgrano | EM | C13 | NaN | 2017-10-27T00:00:00Z | 15 | FUENTES Y ASOCIADOS S.A. | EDENOR SA | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.54666 | -58.44965 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.2 | 10.0 | 0.4 | 2.00 | 0.800 | Aperturas | NaN | PLAN | FIGUEROA ALCORTA, PRES. AV. 7601, CABA | ACERA | 0.0 |
| 1 | cancelled | 0.0 | regular | 4.0 | 120825 | 150020505420 | NaN | 2017-10-13T11:27:36Z | Villa Devoto | EM | C11 | NaN | 2017-10-27T00:00:00Z | 15 | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61127 | -58.52217 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.2 | 0.2 | 0.2 | 0.04 | 0.008 | Aperturas | NaN | PLAN | NAVARRO 5072, CABA | ACERA | 0.0 |
| 2 | cancelled | 0.0 | regular | 4.0 | 121443 | 150020510714 | NaN | 2017-10-17T14:04:57Z | Monte Castro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61922 | -58.50749 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 0.6 | 1.2 | 0.36 | 0.432 | Aperturas | NaN | PLAN | LASCANO 4817 | ACERA | 0.0 |
| 3 | cancelled | 0.0 | regular | 4.0 | 121446 | 150020510720 | NaN | 2017-10-17T14:04:58Z | Monte Castro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61922 | -58.50749 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 0.6 | 1.2 | 0.36 | 0.432 | Aperturas | NaN | PLAN | LASCANO 4871 | ACERA | 0.0 |
| 4 | cancelled | 0.0 | regular | 4.0 | 121449 | 150020510710 | NaN | 2017-10-17T14:04:58Z | Monte Castro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61922 | -58.50749 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 0.6 | 1.2 | 0.36 | 0.432 | Aperturas | NaN | PLAN | LASCANO 4895 | ACERA | 0.0 |
| 5 | cancelled | 0.0 | regular | 4.0 | 121460 | 150020511010 | NaN | 2017-10-17T14:04:58Z | Monte Castro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61866 | -58.50642 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 0.6 | 1.2 | 0.36 | 0.432 | Aperturas | NaN | PLAN | LASCANO 4797 | ACERA | 0.0 |
| 6 | cancelled | 0.0 | regular | 4.0 | 121463 | 150020511114 | NaN | 2017-10-17T14:04:58Z | Monte Castro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61781 | -58.50482 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 0.6 | 1.2 | 0.36 | 0.432 | Aperturas | NaN | PLAN | LASCANO 4625 | ACERA | 0.0 |
| 7 | cancelled | 0.0 | regular | 4.0 | 121471 | 150020511111 | NaN | 2017-10-17T14:04:59Z | Monte Castro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.61813 | -58.50542 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 5.0 | 0.6 | 3.00 | 1.800 | Aperturas | NaN | PLAN | LASCANO 4695 | ACERA | 0.0 |
| 8 | complete | 18.0 | regular | 4.0 | 8823 | 150019832130 | NaN | NaN | Recoleta | EM | C02 | NaN | 2017-08-12T00:00:00Z | 3 | RADIOTRONICA DE ARGENTINA SA | TELEF?NICA DE ARGENTINA SOCIEDAD AN | A_DME | 2017-08-10T00:00:00Z | NaN | VE5 | 2017-08-08T00:00:00Z | -34.58818 | -58.39861 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.2 | 1.0 | 1.20 | 1.200 | Rojas Natalia | 3.0 | SERV | PUEYRREDON AV. 2030, CABA | ACERA | NaN |
| 9 | cancelled | 0.0 | regular | 4.0 | 121489 | 150020511314 | NaN | 2017-10-17T14:05:00Z | Villa Luro | EM | C10 | NaN | 2017-10-27T00:00:00Z | 15 | AUTOTROL S.A.CONSTRUMAN S.A. UTE | AUTOTROL S.A.CONSTRUMAN S.A. UTE | NaN | 2017-10-27T00:00:00Z | NaN | VE4 | 2017-10-13T00:00:00Z | -34.63273 | -58.50647 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.6 | 0.6 | 1.2 | 0.36 | 0.432 | Aperturas | NaN | PLAN | HUGO, VICTOR 621 | ACERA | 0.0 |
Last rows
| activity_status | activitynumber | activitytype | activitywotype | aid | apptnumber | atime_of_assignment | atime_of_booking | barrio | clase_aviso | comuna | ctime_delivered_end | date | duracion | empresa_contratista | empresa_solicitante | estado_general | fin_obra | gp_nuevo | grupo_planificador | inicio_obra | latitude | longitude | mobileactacomproba | mobileactaintima | mobileactasecuestro | mobilec01 | mobilec02 | mobilec03 | mobilec06 | mobilec07 | mobilec08 | mobilec09 | mobilec10 | mobilec11 | mobilec12 | mobilec13 | mobilec14 | mobilec15 | mobilec16 | mobilec17 | mobilec18 | mobilec20 | mobilec21 | mobilec22 | mobilec23 | mobilec24 | mobilec25 | mobilec26 | mobilec27 | mobilec28 | mobilec29 | mobilec30 | mobilec31 | mobilec32 | mobilec33 | mobilec34 | mobiledesnivel | mobileseveridad | no_realizado | obra_ancho | obra_largo | obra_profundidad | obra_superficie_m2 | obra_volumen_m3 | resource_name | severidad | status_usuario | streetaddress | tipo_obra | traveltime | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1078339 | complete | NaN | regular | NaN | 1350926 | 190002478710 | 2019-05-16T11:58:01Z | 2019-05-15T21:13:36Z | Palermo | CG | C14 | NaN | 2019-05-17T00:00:00Z | 7 | EMA SERVICIOS S.A. | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | AC_NEA | 2019-05-22T00:00:00Z | NaN | VE4 | 2019-05-16T00:00:00Z | -34.58777 | -58.41830 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.6 | 0.6 | 0.60 | 0.36 | 0.216 | JTOURNIER | NaN | INEX | ARAOZ 2267 | ACERA | 7.0 |
| 1078340 | complete | NaN | regular | NaN | 1273359 | 140010569010 | 2019-05-16T12:13:56Z | 2019-04-16T12:04:13Z | Palermo | AP | C14 | NaN | 2019-05-17T00:00:00Z | 7 | IBERCOM MULTICOM S.A | NSS S.A. | A_DBE | 2018-12-14T00:00:00Z | NaN | VE6 | 2018-12-08T00:00:00Z | -34.58815 | -58.41298 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.4 | 2.0 | 0.80 | 0.80 | 0.640 | JTOURNIER | NaN | REOK | VIDT 2098 | ACERA | 18.0 |
| 1078341 | suspended | NaN | regular | NaN | 1356164 | 150025491711 | 2019-05-16T11:58:01Z | 2019-05-10T15:13:08Z | Palermo | EM | C14 | NaN | 2019-05-17T00:00:00Z | 15 | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | NaN | 2019-05-24T00:00:00Z | NaN | VE4 | 2019-05-10T00:00:00Z | -34.59590 | -58.42141 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 1.0 | 0.6 | 0.40 | 0.60 | 0.240 | JTOURNIER | NaN | PLAN | ACUÑA DE FIGUEROA, FRANCISCO 1388 | ACERA | 0.0 |
| 1078342 | suspended | NaN | regular | NaN | 1356165 | 140010692830 | 2019-05-16T12:13:56Z | 2019-04-08T06:56:45Z | Palermo | AP | C14 | NaN | 2019-05-17T00:00:00Z | 30 | LUBRISIDER S.A. | EDENOR SA | NaN | 2018-12-18T00:00:00Z | NaN | VE5 | 2018-11-19T00:00:00Z | -34.59708 | -58.42165 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.4 | 13.0 | 1.10 | 5.20 | 5.720 | JTOURNIER | NaN | PLAN | ACUÑA DE FIGUEROA, FRANCISCO 1264 | ACERA | 1.0 |
| 1078343 | suspended | NaN | regular | NaN | 1356166 | 150024781530 | 2019-05-16T12:13:56Z | 2019-02-28T12:03:00Z | Palermo | EM | C14 | NaN | 2019-05-17T00:00:00Z | 15 | ZUBDESA S.A | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | NaN | 2019-02-22T00:00:00Z | NaN | VE7 | 2019-02-08T00:00:00Z | -34.59705 | -58.42326 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 1.0 | 1.0 | 1.00 | 1.00 | 1.000 | JTOURNIER | NaN | PLAN | GASCON 1192 | ACERA | 1.0 |
| 1078344 | suspended | NaN | regular | NaN | 1356167 | 190002428820 | 2019-05-16T11:58:01Z | 2019-05-06T08:19:02Z | Palermo | CG | C14 | NaN | 2019-05-17T00:00:00Z | 15 | ZUBDESA S.A | AGUA Y SANEAMIENTOS ARGENTINOS SOCI | NaN | 2019-05-17T00:00:00Z | NaN | VE4 | 2019-05-03T00:00:00Z | -34.59596 | -58.41987 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 1.0 | 1.0 | 1.00 | 1.00 | 1.000 | JTOURNIER | NaN | PLAN | MEDRANO 1131 | ACERA | 0.0 |
| 1078345 | suspended | NaN | regular | NaN | 1356168 | 140010743220 | 2019-05-16T12:13:56Z | 2019-03-12T18:03:20Z | Palermo | AP | C14 | NaN | 2019-05-17T00:00:00Z | 16 | DOMINION INDUSTRY ARGENTINA S.A | TELEFONICA DE ARGENTINA S.A. | NaN | 2018-12-23T00:00:00Z | NaN | VE7 | 2018-12-08T00:00:00Z | -34.59653 | -58.41935 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.4 | 100.0 | 0.70 | 40.00 | 28.000 | JTOURNIER | NaN | PLAN | CABRERA, JOSE A. 3701 | ACERA | 0.0 |
| 1078346 | suspended | NaN | regular | NaN | 1356169 | 140011396720 | 2019-05-16T11:58:01Z | 2019-04-26T21:42:17Z | Palermo | AP | C14 | NaN | 2019-05-17T00:00:00Z | 22 | RETESAR S.A. | TELEFONICA DE ARGENTINA S.A. | NaN | 2019-05-18T00:00:00Z | NaN | VE4 | 2019-04-27T00:00:00Z | -34.59653 | -58.41935 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.4 | 100.0 | 0.70 | 40.00 | 28.000 | JTOURNIER | NaN | PLAN | CABRERA, JOSE A. 3799 | ACERA | 0.0 |
| 1078347 | suspended | NaN | regular | NaN | 1356170 | 150024684310 | 2019-05-16T12:13:56Z | 2019-03-06T15:01:53Z | Palermo | EM | C14 | NaN | 2019-05-17T00:00:00Z | 28 | EDENOR SA | EDENOR SA | NaN | 2019-02-26T00:00:00Z | NaN | VE7 | 2019-01-30T00:00:00Z | -34.59379 | -58.42322 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.4 | 10.0 | 0.65 | 4.00 | 2.600 | JTOURNIER | NaN | PLAN | HONDURAS 4270 | ACERA | 0.0 |
| 1078348 | suspended | NaN | regular | NaN | 1356171 | 140010646880 | 2019-05-16T12:13:56Z | 2019-04-16T12:04:12Z | Palermo | AP | C14 | NaN | 2019-05-17T00:00:00Z | 30 | SUPPLY SOUTH SRL | EDENOR SA | NaN | 2018-12-05T00:00:00Z | NaN | VE6 | 2018-11-06T00:00:00Z | -34.59545 | -58.41916 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | otros | 0.4 | 60.0 | 0.65 | 24.00 | 15.600 | JTOURNIER | NaN | PLAN | GORRITI 3835 | ACERA | 0.0 |